package com.apes.fa.respository;

import com.apes.fa.model.InventoryTransferAssetItem;
import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;


public interface InventoryTransferAssetItemRepository extends CustomRepository<InventoryTransferAssetItem, String> {

    @Query(value = "SELECT e FROM InventoryTransferAssetItem e WHERE e.id NOT IN :itemIds AND e.inventoryTransferAsset.id = :inventory_transfer_asset_id ")
    List<InventoryTransferAssetItem> findDeleteProItem(@Param("inventory_transfer_asset_id") String inventoryTransferAssetId, @Param("itemIds") List itemIds);
}
